Skip to main content

SUM

Returns the sum of a series of numbers and/or cells.

[SUM for BigQuery]

Returns the sum of a data column.

Sample Usage​

=SUM(table_name!inventory)

Syntax​

SUM(column)

  • column - The data column to consider when calculating the sum.

Tip: Returning sum across multiple columns is not supported.

Sample Usage​

SUM(A2:A100)

SUM(1,2,3,4,5)

SUM(1,2,A2:A50)

Syntax​

SUM(value1, [value2, ...])

  • value1 - The first number or range to add together.
  • value2, ... - [ OPTIONAL ] - Additional numbers or ranges to add to value1.

Notes​

  • If only a single number for value1 is supplied, SUM returns value1.
  • Although SUM is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

See Also​

SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.

SUMIF: Returns a conditional sum across a range.

SERIESSUM: Given parameters x, n, m, and a, returns the power series sum a1x^n^ + a2x^(n+m)^ + ... + aix^(n+(i-1)m)^, where i is the number of entries in range `a`.

QUOTIENT: Returns one number divided by another, without the remainder.

PRODUCT: Returns the result of multiplying a series of numbers together.

MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.

MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.

DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.

ADD: Returns the sum of two numbers. Equivalent to the `+` operator.

Examples​